Tabela Transplantation

Definicja tabeli Transplantation

Name

Transplantation

Code

Transplantation

Comment

Dane przeszczepów


Lista kolumn tabeli Transplantation

Name

Code

TransplantationID

TransplantationID

PersonID

PersonID

EntryDate

EntryDate

DictionaryValueID

DictionaryValueID

TransplantDate

TransplantDate

Organ

Organ

Comments

Comments

InsertingPerson

InsertingPerson

InsertDate

InsertDate

LastModifiedPerson

LastModifiedPerson

LastModifiedDT

LastModifiedDT


Kolumna TransplantationID tabeli Transplantation

Definicja kolumny TransplantationID tabeli Transplantation

Name

TransplantationID

Code

TransplantationID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PersonID tabeli Transplantation

Definicja kolumny PersonID tabeli Transplantation

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna EntryDate tabeli Transplantation

Definicja kolumny EntryDate tabeli Transplantation

Name

EntryDate

Code

EntryDate

Data Type

DATE

Mandatory

No

Comment

Data wpisu


Kolumna DictionaryValueID tabeli Transplantation

Definicja kolumny DictionaryValueID tabeli Transplantation

Name

DictionaryValueID

Code

DictionaryValueID

Data Type

NUMBER(10)

Mandatory

No

Comment

Status przeszczepu


Kolumna TransplantDate tabeli Transplantation

Definicja kolumny TransplantDate tabeli Transplantation

Name

TransplantDate

Code

TransplantDate

Data Type

DATE

Mandatory

No

Comment

Data przeszczepu


Kolumna Organ tabeli Transplantation

Definicja kolumny Organ tabeli Transplantation

Name

Organ

Code

Organ

Data Type

NUMBER(10)

Mandatory

No

Comment

Organ


Kolumna Comments tabeli Transplantation

Definicja kolumny Comments tabeli Transplantation

Name

Comments

Code

Comments

Data Type

VARCHAR2(200)

Mandatory

No

Comment

 


Kolumna InsertingPerson tabeli Transplantation

Definicja kolumny InsertingPerson tabeli Transplantation

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna InsertDate tabeli Transplantation

Definicja kolumny InsertDate tabeli Transplantation

Name

InsertDate

Code

InsertDate

Data Type

DATE

Mandatory

Yes

Comment

 


Kolumna LastModifiedPerson tabeli Transplantation

Definicja kolumny LastModifiedPerson tabeli Transplantation

Name

LastModifiedPerson

Code

LastModifiedPerson

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna LastModifiedDT tabeli Transplantation

Definicja kolumny LastModifiedDT tabeli Transplantation

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

Yes

Comment

 


Lista kluczy tabeli Transplantation

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Transplantation

Definicja klucza Identifier_1 tabeli Transplantation

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment